Previous Topic

Next Topic

Report and query performance maintenance

iMIS reports and queries draw information from a variety of source and interim tables. If you have a large amount of customer data or if you run reports or queries frequently, you may see performance slow down over time. In this version of iMIS there are two enhancements that address this type of performance issue.

Fund Raising report performance has been enhanced by adding a utility that can retrieve and precalculate the Fund Raising data used by reports. See Reporting performance enhancement for large Fund Raising data sets for more information.

Report and query performance for all modules has been enhanced with the addition of a script that discards data from the interim tables that store query results. You can either run this script on a regular schedule, or you can run it if you notice that reports and queries are taking progressively longer to run.

In This Section

Clearing old query results

See Also

Reporting changes

AR Cash reports

Customer reports

Dues reports

Events reports

Fund Raising reports

Opportunity Management reports

IQA reports


ASI logo 10.6 Production Release. Updated 3/6/2006 10:09:01 AM
© 2009 by Advanced Solutions International, Inc. All rights reserved.